package com.example.gmallpublisher.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.mybatis.spring.annotation.MapperScan;

import java.math.BigDecimal;

//告诉程序 我要找到指定接口

public interface TradeStatsMapper {
    //获取交易额
    @Select("select sum(order_amount) order_amount from dws_trade_province_order_window PARTITION (par#{date})")
    BigDecimal selectGMV(Integer date);
}

